/*
 Navicat Premium Data Transfer

 Source Server         : java
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : localhost:3306
 Source Schema         : javaweb

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 14/04/2022 22:08:06
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for rel_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `rel_role_permission`;
CREATE TABLE `rel_role_permission` (
                                       `id` int NOT NULL AUTO_INCREMENT,
                                       `roleId` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色号',
                                       `perCode` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '权限代码',
                                       PRIMARY KEY (`id`,`roleId`,`perCode`) USING BTREE,
                                       KEY `perCode` (`perCode`) USING BTREE,
                                       KEY `RRProleId` (`roleId`) USING BTREE,
                                       CONSTRAINT `RRPperCode` FOREIGN KEY (`perCode`) REFERENCES `sys_permission` (`perCode`) ON DELETE CASCADE ON UPDATE CASCADE,
                                       CONSTRAINT `RRProleId` FOREIGN KEY (`roleId`) REFERENCES `sys_role` (`roleId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=417 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色权限关联表';

-- ----------------------------
-- Records of rel_role_permission
-- ----------------------------
BEGIN;
INSERT INTO `rel_role_permission` VALUES (371, '1', 'admin:address:select');
INSERT INTO `rel_role_permission` VALUES (374, '1', 'admin:order:select');
INSERT INTO `rel_role_permission` VALUES (403, '1', 'admin:permission:delete');
INSERT INTO `rel_role_permission` VALUES (405, '1', 'admin:permission:findPermissionByRoleId');
INSERT INTO `rel_role_permission` VALUES (389, '1', 'admin:permission:insert');
INSERT INTO `rel_role_permission` VALUES (401, '1', 'admin:permission:managePermission');
INSERT INTO `rel_role_permission` VALUES (381, '1', 'admin:permission:select');
INSERT INTO `rel_role_permission` VALUES (395, '1', 'admin:permission:selectById');
INSERT INTO `rel_role_permission` VALUES (390, '1', 'admin:permission:update');
INSERT INTO `rel_role_permission` VALUES (402, '1', 'admin:role:delete');
INSERT INTO `rel_role_permission` VALUES (380, '1', 'admin:role:insert');
INSERT INTO `rel_role_permission` VALUES (399, '1', 'admin:role:update');
INSERT INTO `rel_role_permission` VALUES (396, '1', 'admin:user:delete');
INSERT INTO `rel_role_permission` VALUES (382, '1', 'admin:user:select');
INSERT INTO `rel_role_permission` VALUES (414, '1', 'anon:role:select');
INSERT INTO `rel_role_permission` VALUES (409, '1', 'anon:role:selectById');
INSERT INTO `rel_role_permission` VALUES (411, '1', 'anon:role:selectUserRole');
INSERT INTO `rel_role_permission` VALUES (408, '1', 'anon:user:insert');
INSERT INTO `rel_role_permission` VALUES (413, '1', 'anon:user:login');
INSERT INTO `rel_role_permission` VALUES (412, '1', 'anon:user:selectByName');
INSERT INTO `rel_role_permission` VALUES (361, '3', 'anon:user:update');
INSERT INTO `rel_role_permission` VALUES (410, '1', 'anon:user:update');
INSERT INTO `rel_role_permission` VALUES (337, '2', 'buyer:commodity:select');
INSERT INTO `rel_role_permission` VALUES (378, '1', 'buyer:commodity:select');
INSERT INTO `rel_role_permission` VALUES (331, '2', 'buyer:commodity:selectByPriceBetween');
INSERT INTO `rel_role_permission` VALUES (373, '1', 'buyer:commodity:selectByPriceBetween');
INSERT INTO `rel_role_permission` VALUES (324, '2', 'buyer:commodity:selectByQuantityBetween');
INSERT INTO `rel_role_permission` VALUES (369, '1', 'buyer:commodity:selectByQuantityBetween');
INSERT INTO `rel_role_permission` VALUES (334, '2', 'buyer:commodity:selectByQuantityNow');
INSERT INTO `rel_role_permission` VALUES (393, '1', 'buyer:commodity:selectByQuantityNow');
INSERT INTO `rel_role_permission` VALUES (335, '2', 'buyer:commodity:selectCommodityUser');
INSERT INTO `rel_role_permission` VALUES (392, '1', 'buyer:commodity:selectCommodityUser');
INSERT INTO `rel_role_permission` VALUES (323, '2', 'buyer:commodity:updateRate');
INSERT INTO `rel_role_permission` VALUES (368, '1', 'buyer:commodity:updateRate');
INSERT INTO `rel_role_permission` VALUES (341, '2', 'buyer:order:insert');
INSERT INTO `rel_role_permission` VALUES (379, '1', 'buyer:order:insert');
INSERT INTO `rel_role_permission` VALUES (416, '1', 'inner:order:delete');
INSERT INTO `rel_role_permission` VALUES (415, '1', 'inner:user:toLogin');
INSERT INTO `rel_role_permission` VALUES (362, '3', 'saler:commodity:delete');
INSERT INTO `rel_role_permission` VALUES (383, '1', 'saler:commodity:delete');
INSERT INTO `rel_role_permission` VALUES (363, '3', 'saler:commodity:deleteAllZero');
INSERT INTO `rel_role_permission` VALUES (385, '1', 'saler:commodity:deleteAllZero');
INSERT INTO `rel_role_permission` VALUES (358, '3', 'saler:commodity:insert');
INSERT INTO `rel_role_permission` VALUES (398, '1', 'saler:commodity:insert');
INSERT INTO `rel_role_permission` VALUES (343, '2', 'user:address:delete');
INSERT INTO `rel_role_permission` VALUES (360, '3', 'user:address:delete');
INSERT INTO `rel_role_permission` VALUES (404, '1', 'user:address:delete');
INSERT INTO `rel_role_permission` VALUES (325, '2', 'user:address:deleteByName');
INSERT INTO `rel_role_permission` VALUES (346, '3', 'user:address:deleteByName');
INSERT INTO `rel_role_permission` VALUES (366, '1', 'user:address:deleteByName');
INSERT INTO `rel_role_permission` VALUES (338, '2', 'user:address:insert');
INSERT INTO `rel_role_permission` VALUES (355, '3', 'user:address:insert');
INSERT INTO `rel_role_permission` VALUES (376, '1', 'user:address:insert');
INSERT INTO `rel_role_permission` VALUES (333, '2', 'user:address:selectByName');
INSERT INTO `rel_role_permission` VALUES (353, '3', 'user:address:selectByName');
INSERT INTO `rel_role_permission` VALUES (391, '1', 'user:address:selectByName');
INSERT INTO `rel_role_permission` VALUES (339, '2', 'user:address:update');
INSERT INTO `rel_role_permission` VALUES (356, '3', 'user:address:update');
INSERT INTO `rel_role_permission` VALUES (377, '1', 'user:address:update');
INSERT INTO `rel_role_permission` VALUES (328, '2', 'user:commodity:selectByAnyParam');
INSERT INTO `rel_role_permission` VALUES (349, '3', 'user:commodity:selectByAnyParam');
INSERT INTO `rel_role_permission` VALUES (370, '1', 'user:commodity:selectByAnyParam');
INSERT INTO `rel_role_permission` VALUES (326, '2', 'user:commodity:selectById');
INSERT INTO `rel_role_permission` VALUES (347, '3', 'user:commodity:selectById');
INSERT INTO `rel_role_permission` VALUES (386, '1', 'user:commodity:selectById');
INSERT INTO `rel_role_permission` VALUES (332, '2', 'user:commodity:selectByName');
INSERT INTO `rel_role_permission` VALUES (352, '3', 'user:commodity:selectByName');
INSERT INTO `rel_role_permission` VALUES (372, '1', 'user:commodity:selectByName');
INSERT INTO `rel_role_permission` VALUES (327, '2', 'user:commodity:selectUserCommodity');
INSERT INTO `rel_role_permission` VALUES (348, '3', 'user:commodity:selectUserCommodity');
INSERT INTO `rel_role_permission` VALUES (367, '1', 'user:commodity:selectUserCommodity');
INSERT INTO `rel_role_permission` VALUES (330, '2', 'user:commodity:update');
INSERT INTO `rel_role_permission` VALUES (351, '3', 'user:commodity:update');
INSERT INTO `rel_role_permission` VALUES (388, '1', 'user:commodity:update');
INSERT INTO `rel_role_permission` VALUES (329, '2', 'user:gitee:refreshPage');
INSERT INTO `rel_role_permission` VALUES (350, '3', 'user:gitee:refreshPage');
INSERT INTO `rel_role_permission` VALUES (387, '1', 'user:gitee:refreshPage');
INSERT INTO `rel_role_permission` VALUES (344, '2', 'user:gitee:saveImg');
INSERT INTO `rel_role_permission` VALUES (364, '3', 'user:gitee:saveImg');
INSERT INTO `rel_role_permission` VALUES (384, '1', 'user:gitee:saveImg');
INSERT INTO `rel_role_permission` VALUES (336, '2', 'user:order:selectByAnyParam');
INSERT INTO `rel_role_permission` VALUES (354, '3', 'user:order:selectByAnyParam');
INSERT INTO `rel_role_permission` VALUES (375, '1', 'user:order:selectByAnyParam');
INSERT INTO `rel_role_permission` VALUES (345, '2', 'user:order:selectById');
INSERT INTO `rel_role_permission` VALUES (365, '3', 'user:order:selectById');
INSERT INTO `rel_role_permission` VALUES (394, '1', 'user:order:selectById');
INSERT INTO `rel_role_permission` VALUES (340, '2', 'user:order:update');
INSERT INTO `rel_role_permission` VALUES (357, '3', 'user:order:update');
INSERT INTO `rel_role_permission` VALUES (397, '1', 'user:order:update');
INSERT INTO `rel_role_permission` VALUES (407, '1', 'user:upload:export');
INSERT INTO `rel_role_permission` VALUES (406, '1', 'user:upload:import');
INSERT INTO `rel_role_permission` VALUES (342, '2', 'user:user:logout');
INSERT INTO `rel_role_permission` VALUES (359, '3', 'user:user:logout');
INSERT INTO `rel_role_permission` VALUES (400, '1', 'user:user:logout');
COMMIT;

-- ----------------------------
-- Table structure for rel_user_commodity
-- ----------------------------
DROP TABLE IF EXISTS `rel_user_commodity`;
CREATE TABLE `rel_user_commodity` (
                                      `id` int NOT NULL AUTO_INCREMENT COMMENT '序号',
                                      `comId` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '商品号',
                                      `userName` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名',
                                      PRIMARY KEY (`id`) USING BTREE,
                                      KEY `name` (`userName`) USING BTREE,
                                      KEY `id` (`comId`) USING BTREE,
                                      CONSTRAINT `RUCcomId` FOREIGN KEY (`comId`) REFERENCES `sys_commodity` (`comId`) ON DELETE CASCADE ON UPDATE CASCADE,
                                      CONSTRAINT `RUCuserName` FOREIGN KEY (`userName`) REFERENCES `sys_user` (`userName`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户商品关联表';

-- ----------------------------
-- Records of rel_user_commodity
-- ----------------------------
BEGIN;
INSERT INTO `rel_user_commodity` VALUES (1, '厨具001', 'admin');
INSERT INTO `rel_user_commodity` VALUES (2, '器械001', 'admin');
INSERT INTO `rel_user_commodity` VALUES (3, '宠物001', 'admin');
INSERT INTO `rel_user_commodity` VALUES (4, '家具001', 'admin');
INSERT INTO `rel_user_commodity` VALUES (5, '家具002', 'admin');
INSERT INTO `rel_user_commodity` VALUES (6, '服饰001', 'admin');
INSERT INTO `rel_user_commodity` VALUES (7, '生活001', 'admin');
INSERT INTO `rel_user_commodity` VALUES (8, '电器001', 'admin');
INSERT INTO `rel_user_commodity` VALUES (9, '饰品001', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for rel_user_role
-- ----------------------------
DROP TABLE IF EXISTS `rel_user_role`;
CREATE TABLE `rel_user_role` (
                                 `id` int NOT NULL AUTO_INCREMENT COMMENT '序号',
                                 `userName` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名',
                                 `roleId` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色号',
                                 PRIMARY KEY (`id`) USING BTREE,
                                 KEY `userName` (`userName`) USING BTREE,
                                 KEY `roleId` (`roleId`) USING BTREE,
                                 CONSTRAINT `RURroleId` FOREIGN KEY (`roleId`) REFERENCES `sys_role` (`roleId`) ON DELETE CASCADE ON UPDATE CASCADE,
                                 CONSTRAINT `RURuserName` FOREIGN KEY (`userName`) REFERENCES `sys_user` (`userName`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户角色关联表';

-- ----------------------------
-- Records of rel_user_role
-- ----------------------------
BEGIN;
INSERT INTO `rel_user_role` VALUES (1, 'admin', '1');
INSERT INTO `rel_user_role` VALUES (2, 'buyer', '2');
INSERT INTO `rel_user_role` VALUES (3, 'test', '1');
INSERT INTO `rel_user_role` VALUES (4, 'saler', '3');
INSERT INTO `rel_user_role` VALUES (5, 'buyer2', '2');
INSERT INTO `rel_user_role` VALUES (6, 'saler2', '3');
COMMIT;

-- ----------------------------
-- Table structure for sec_block_chain
-- ----------------------------
DROP TABLE IF EXISTS `sec_block_chain`;
CREATE TABLE `sec_block_chain` (
                                   `id` int NOT NULL AUTO_INCREMENT COMMENT '序号',
                                   `data` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '数据',
                                   `hash` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '哈希值',
                                   `previousHash` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '上一个区块哈希值',
                                   `timeStamp` bigint DEFAULT NULL COMMENT '时间戳',
                                   `nonce` int DEFAULT NULL COMMENT '一次性值',
                                   PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='安全区块链';

-- ----------------------------
-- Records of sec_block_chain
-- ----------------------------
BEGIN;
INSERT INTO `sec_block_chain` VALUES (12, '1649943567760', '0000005f59593281928382379c2c4e014b98d0b0f010ad2665273f6ec423c472', '0', 1649943567915, 1923206);
COMMIT;

-- ----------------------------
-- Table structure for sys_commodity
-- ----------------------------
DROP TABLE IF EXISTS `sys_commodity`;
CREATE TABLE `sys_commodity` (
                                 `comId` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '商品号',
                                 `comName` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
                                 `comQuantity` int NOT NULL COMMENT '数量',
                                 `comQuantityNow` int NOT NULL COMMENT '当前数量',
                                 `comEachPrice` double NOT NULL COMMENT '单价',
                                 `comDescription` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '描述',
                                 `comRateCount` int NOT NULL COMMENT '评价次数',
                                 `comRate` double NOT NULL COMMENT '评价',
                                 `comPicture` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片',
                                 `utcCreate` bigint NOT NULL COMMENT '创建时间',
                                 `utcModify` bigint NOT NULL COMMENT '修改时间',
                                 `modifyBy` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '修改人',
                                 `valid` bit(1) NOT NULL COMMENT '是否有效',
                                 `remark` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
                                 `customa` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '自定义字段a',
                                 `customb` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '自定义字段b',
                                 PRIMARY KEY (`comId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统商品表';

-- ----------------------------
-- Records of sys_commodity
-- ----------------------------
BEGIN;
INSERT INTO `sys_commodity` VALUES ('厨具001', '不锈钢菜刀', 88, 84, 6.8, '一套不锈钢刀具', 2, 2.5, 'https://tremblingoss.oss-cn-shanghai.aliyuncs.com/2022/04/14/%E6%88%AA%E5%B1%8F2022-04-14%2021.29.12.png', 1622906027922, 1649943577520, 'admin', b'1', NULL, NULL, NULL);
INSERT INTO `sys_commodity` VALUES ('器械001', '洒水器', 100, 0, 18, '360°农业自动洒水器', 1, 4, 'https://tremblingoss.oss-cn-shanghai.aliyuncs.com/2022/04/14/%E6%88%AA%E5%B1%8F2022-04-14%2021.29.50.png', 1622905868083, 1622906240524, 'buyer', b'1', NULL, NULL, NULL);
INSERT INTO `sys_commodity` VALUES ('宠物001', '领养博美幼犬', 1, 0, 12, '只需运费！！！', 1, 2, 'https://tremblingoss.oss-cn-shanghai.aliyuncs.com/2022/04/14/%E6%88%AA%E5%B1%8F2022-04-14%2021.30.05.png', 1621874264014, 1622906166458, 'buyer2', b'1', NULL, NULL, NULL);
INSERT INTO `sys_commodity` VALUES ('家具001', '大理石圆桌', 6, 6, 68, '轻奢大理石装饰桌', 1, 3, 'https://tremblingoss.oss-cn-shanghai.aliyuncs.com/2022/04/14/%E6%88%AA%E5%B1%8F2022-04-14%2021.31.22.png', 1622906064592, 1622906069218, 'saler2', b'1', NULL, NULL, NULL);
INSERT INTO `sys_commodity` VALUES ('家具002', '吊椅', 100, 100, 9.9, '塑料鸟巢吊椅', 1, 4, 'https://tremblingoss.oss-cn-shanghai.aliyuncs.com/2022/04/14/%E6%88%AA%E5%B1%8F2022-04-14%2021.31.44.png', 1622906113406, 1622906119980, 'saler2', b'1', NULL, NULL, NULL);
INSERT INTO `sys_commodity` VALUES ('服饰001', '帆布鞋', 40, 40, 15, '平底匡威帆布鞋', 1, 5, 'https://tremblingoss.oss-cn-shanghai.aliyuncs.com/2022/04/14/%E6%88%AA%E5%B1%8F2022-04-14%2021.32.07.png', 1622905960142, 1622905967742, 'saler', b'1', NULL, NULL, NULL);
INSERT INTO `sys_commodity` VALUES ('生活001', '防紫外线伞', 100, 96, 5, '临时用伞', 2, 4.5, 'https://tremblingoss.oss-cn-shanghai.aliyuncs.com/2022/04/14/%E6%88%AA%E5%B1%8F2022-04-14%2021.32.32.png', 1621874739991, 1622906271399, 'buyer', b'1', NULL, NULL, NULL);
INSERT INTO `sys_commodity` VALUES ('电器001', '大容量移动电源', 5, 5, 50, '淘宝同款超大容量移动电源', 1, 3.5, 'https://tremblingoss.oss-cn-shanghai.aliyuncs.com/2022/04/14/%E6%88%AA%E5%B1%8F2022-04-14%2021.32.56.png', 1621874459351, 1622226485034, 'admin', b'1', NULL, NULL, NULL);
INSERT INTO `sys_commodity` VALUES ('饰品001', '情侣项链', 2, 1, 6, '两对情侣纯银项链', 1, 2.5, 'https://tremblingoss.oss-cn-shanghai.aliyuncs.com/2022/04/14/%E6%88%AA%E5%B1%8F2022-04-14%2021.33.16.png', 1622905912372, 1622906255620, 'buyer', b'1', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_order
-- ----------------------------
DROP TABLE IF EXISTS `sys_order`;
CREATE TABLE `sys_order` (
                             `id` int NOT NULL AUTO_INCREMENT COMMENT '序号',
                             `orderComId` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '交易商品',
                             `orderSalerName` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '卖家账号',
                             `orderBuyerName` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '买家账号',
                             `orderSalerAddress` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发货地址',
                             `orderBuyerAddress` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '收货地址',
                             `orderTransportCode` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '运单号',
                             `orderCreateTime` bigint DEFAULT NULL COMMENT '创建时间',
                             `orderTransportTime` bigint DEFAULT NULL COMMENT '发货时间',
                             `orderReceiveTime` bigint DEFAULT NULL COMMENT '收货时间',
                             `orderStatus` int NOT NULL COMMENT '订单状态\n1：已下单\n2：已发货\n3：已收货',
                             `orderPayStatus` int NOT NULL COMMENT '付款状态\n1：已付款\n2：未付款',
                             `orderTime` bigint NOT NULL COMMENT '截止时间',
                             `utcCreate` bigint NOT NULL COMMENT '创建时间',
                             `utcModify` bigint NOT NULL COMMENT '修改时间',
                             `modifyBy` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '修改人',
                             `valid` bit(1) NOT NULL COMMENT '是否有效',
                             `remark` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
                             `customa` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '自定义字段a',
                             `customb` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '自定义字段b',
                             PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统订单表';

-- ----------------------------
-- Records of sys_order
-- ----------------------------
BEGIN;
INSERT INTO `sys_order` VALUES (8, '厨具001', 'saler2', 'buyer2', '2号出租方地址', '2号买家地址', '1978657234', 1622906149437, 1622906329036, 1649943600714, 3, 2, 1650548400714, 1622906150412, 1622906150412, 'buyer2', b'1', NULL, NULL, NULL);
INSERT INTO `sys_order` VALUES (9, '宠物001', 'saler', 'buyer2', '出租方地址', '2号买家地址', '1857462758', 1622906165060, 1622906295423, NULL, 2, 2, 31536000000, 1622906166450, 1622906166450, 'buyer2', b'1', NULL, NULL, NULL);
INSERT INTO `sys_order` VALUES (10, '器械001', 'saler', 'buyer2', NULL, '2号买家地址', NULL, 1622906186364, NULL, NULL, 1, 2, 2592000000, 1622906187458, 1622906187458, 'buyer2', b'1', NULL, NULL, NULL);
INSERT INTO `sys_order` VALUES (11, '器械001', 'saler', 'buyer', '发货地址1', '买家收货地址', '1968473857', 1622906239345, 1622906309823, 1622906360037, 3, 2, 1623511160037, 1622906240504, 1622906240504, 'buyer', b'1', NULL, NULL, NULL);
INSERT INTO `sys_order` VALUES (12, '饰品001', 'saler', 'buyer', NULL, '浙江理工大学科技与艺术学院', NULL, 1622906253684, NULL, NULL, 1, 2, 604800000, 1622906255598, 1622906255598, 'buyer', b'1', NULL, NULL, NULL);
INSERT INTO `sys_order` VALUES (13, '生活001', 'saler2', 'buyer', '测试发货地址2', '浙江理工大学科技与艺术学院', '1258675623', 1622906270575, 1622906337351, NULL, 2, 2, 2592000000, 1622906271376, 1622906271376, 'buyer', b'1', NULL, NULL, NULL);
INSERT INTO `sys_order` VALUES (14, '厨具001', 'admin', 'admin', NULL, 'admin承租方地址', NULL, 1649943567760, NULL, NULL, 1, 2, 86400000, 1649943577404, 1649943577404, 'admin', b'1', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_permission`;
CREATE TABLE `sys_permission` (
                                  `perId` int NOT NULL AUTO_INCREMENT COMMENT '序号',
                                  `perName` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '权限名',
                                  `perCode` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '代码',
                                  `perUrl` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '请求路径',
                                  `utcCreate` bigint NOT NULL COMMENT '创建时间',
                                  `utcModify` bigint NOT NULL COMMENT '修改时间',
                                  `modifyBy` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '修改人',
                                  `valid` bit(1) NOT NULL COMMENT '是否有效',
                                  `remark` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
                                  `customa` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '自定义字段a',
                                  `customb` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '自定义字段b',
                                  PRIMARY KEY (`perId`,`perCode`) USING BTREE,
                                  KEY `perCode` (`perCode`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统权限表';

-- ----------------------------
-- Records of sys_permission
-- ----------------------------
BEGIN;
INSERT INTO `sys_permission` VALUES (1, '添加用户', 'anon:user:insert', 'user/insert', 1622385207468, 1622385441400, 'admin', b'1', NULL, '0', NULL);
INSERT INTO `sys_permission` VALUES (2, '删除用户', 'admin:user:delete', 'user/delete', 1622385595617, 1622385595617, 'admin', b'1', NULL, '2', NULL);
INSERT INTO `sys_permission` VALUES (3, '更新用户信息', 'anon:user:update', 'user/update', 1622385633154, 1622385633154, 'admin', b'1', NULL, '0', NULL);
INSERT INTO `sys_permission` VALUES (4, '查询全体用户', 'admin:user:select', 'user/select', 1622385708360, 1622385708360, 'admin', b'1', NULL, '2', NULL);
INSERT INTO `sys_permission` VALUES (5, '根据用户名查询用户', 'anon:user:selectByName', 'user/selectByName', 1622385766718, 1622385766718, 'admin', b'1', NULL, '0', NULL);
INSERT INTO `sys_permission` VALUES (6, '用户登陆', 'anon:user:login', 'user/login', 1622385802158, 1622385802158, 'admin', b'1', NULL, '0', NULL);
INSERT INTO `sys_permission` VALUES (7, '用户退出', 'user:user:logout', 'user/logout', 1622385852039, 1622385852039, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (8, '强制登录', 'inner:user:toLogin', 'user/toLogin', 1622385915891, 1622385915891, 'admin', b'1', NULL, '3', NULL);
INSERT INTO `sys_permission` VALUES (9, '添加角色', 'admin:role:insert', 'role/insert', 1622385966197, 1622385966197, 'admin', b'1', NULL, '2', NULL);
INSERT INTO `sys_permission` VALUES (10, '删除角色', 'admin:role:delete', 'role/delete', 1622385990035, 1622385990035, 'admin', b'1', NULL, '2', NULL);
INSERT INTO `sys_permission` VALUES (11, '更新角色', 'admin:role:update', 'role/update', 1622386016974, 1622386016974, 'admin', b'1', NULL, '2', NULL);
INSERT INTO `sys_permission` VALUES (12, '查询全体角色', 'anon:role:select', 'role/select', 1622386179215, 1622386179215, 'admin', b'1', NULL, '0', NULL);
INSERT INTO `sys_permission` VALUES (13, '根据用户名查询角色', 'anon:role:selectUserRole', 'role/selectUserRole', 1622386303575, 1622386303575, 'admin', b'1', NULL, '0', NULL);
INSERT INTO `sys_permission` VALUES (14, '根据角色号查询角色', 'anon:role:selectById', 'role/selectById', 1622386326940, 1622462924531, 'admin', b'1', NULL, '0', NULL);
INSERT INTO `sys_permission` VALUES (15, '添加地址', 'user:address:insert', 'address/insert', 1622386396514, 1622386396514, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (16, '删除地址', 'user:address:delete', 'address/delete', 1622386424450, 1622386424450, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (17, '按用户名删除地址', 'user:address:deleteByName', 'address/deleteByName', 1622386457995, 1622386457995, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (18, '更新地址', 'user:address:update', 'address/update', 1622386484174, 1622386484174, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (19, '查询全部地址', 'admin:address:select', 'address/select', 1622386506544, 1622388921654, 'admin', b'1', NULL, '2', NULL);
INSERT INTO `sys_permission` VALUES (20, '根据用户名查询地址', 'user:address:selectByName', 'address/selectByName', 1622386533492, 1622388926341, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (21, '添加商品', 'saler:commodity:insert', 'commodity/insert', 1622388002204, 1622388002204, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (22, '删除商品', 'saler:commodity:delete', 'commodity/delete', 1622388323569, 1622388323569, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (23, '删除用户无存货商品', 'saler:commodity:deleteAllZero', 'commodity/deleteAllZero', 1622388346996, 1622388346996, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (24, '更新商品信息', 'user:commodity:update', 'commodity/update', 1622388373349, 1622462882618, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (25, '更新商品评价', 'buyer:commodity:updateRate', 'commodity/updateRate', 1622388412021, 1622388412021, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (26, '查询全体商品', 'buyer:commodity:select', 'commodity/select', 1622388455498, 1622388455498, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (27, '根据商品号查询商品', 'user:commodity:selectById', 'commodity/selectById', 1622388490387, 1622388490387, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (28, '根据商品名称查询商品', 'user:commodity:selectByName', 'commodity/selectByName', 1622388517712, 1622388517712, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (29, '根据商品价格包含区间查询商品', 'buyer:commodity:selectByPriceBetween', 'commodity/selectByPriceBetween', 1622388590735, 1622388590735, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (30, '根据商品存货查询商品', 'buyer:commodity:selectByQuantityNow', 'commodity/selectByQuantityNow', 1622388612491, 1622388612491, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (31, '根据商品存货区间查询商品', 'buyer:commodity:selectByQuantityBetween', 'commodity/selectByQuantityBetween', 1622388637591, 1622388637591, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (32, '根据用户名查询商品', 'user:commodity:selectUserCommodity', 'commodity/selectUserCommodity', 1622388669086, 1622388669086, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (33, '根据商品号查询用户', 'buyer:commodity:selectCommodityUser', 'commodity/selectCommodityUser', 1622388710379, 1622388710379, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (34, '根据指定字段查询商品', 'user:commodity:selectByAnyParam', 'commodity/selectByAnyParam', 1622388735338, 1622388908842, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (35, '添加订单', 'buyer:order:insert', 'order/insert', 1622388762483, 1622388762483, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (36, '删除订单', 'inner:order:delete', 'order/delete', 1622388790449, 1622388790449, 'admin', b'1', NULL, '3', NULL);
INSERT INTO `sys_permission` VALUES (37, '更新订单', 'user:order:update', 'order/update', 1622388833428, 1622388833428, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (38, '查询全体订单', 'admin:order:select', 'order/select', 1622388853496, 1622388853496, 'admin', b'1', NULL, '2', NULL);
INSERT INTO `sys_permission` VALUES (39, '根据ID号查询订单', 'user:order:selectById', 'order/selectById', 1622388899751, 1622465413076, 'admin', b'1', NULL, '2', NULL);
INSERT INTO `sys_permission` VALUES (40, '根据指定字段查询订单', 'user:order:selectByAnyParam', 'order/selectByAnyParam', 1622388963543, 1622388963543, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (41, '上传文件', 'user:gitee:saveImg', 'gitee/saveImg', 1622389006703, 1622389006703, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (42, '刷新Gitee Page', 'user:gitee:refreshPage', 'gitee/refreshPage', 1622389031352, 1622389031352, 'admin', b'1', NULL, '1', NULL);
INSERT INTO `sys_permission` VALUES (43, '添加权限', 'admin:permission:insert', 'permission/insert', 1622389069564, 1622389069564, 'admin', b'1', NULL, '2', NULL);
INSERT INTO `sys_permission` VALUES (44, '删除权限', 'admin:permission:delete', 'permission/delete', 1622389091018, 1622389091018, 'admin', b'1', NULL, '2', NULL);
INSERT INTO `sys_permission` VALUES (45, '更新权限', 'admin:permission:update', 'permission/update', 1622389109556, 1622389109556, 'admin', b'1', NULL, '2', NULL);
INSERT INTO `sys_permission` VALUES (46, '查询全体权限', 'admin:permission:select', 'permission/select', 1622389179678, 1622389179678, 'admin', b'1', NULL, '2', NULL);
INSERT INTO `sys_permission` VALUES (47, '根据ID查询权限', 'admin:permission:selectById', 'permission/selectById', 1622389222987, 1622389222987, 'admin', b'1', NULL, '2', NULL);
INSERT INTO `sys_permission` VALUES (48, '根据角色号查询权限', 'admin:permission:findPermissionByRoleId', 'permission/findPermissionByRoleId', 1622432653963, 1622432653963, 'admin', b'1', NULL, '2', NULL);
INSERT INTO `sys_permission` VALUES (49, '创建角色权限链接', 'admin:permission:managePermission', 'permission/managePermission', 1622432679207, 1622432679207, 'admin', b'1', NULL, '2', NULL);
INSERT INTO `sys_permission` VALUES (50, '导入表格', 'user:upload:import', 'upload/importExcel', 1649942560102, 1649942560102, 'admin', b'1', NULL, '2', NULL);
INSERT INTO `sys_permission` VALUES (51, '导出表格', 'user:upload:export', 'upload/export', 1649942598031, 1649942608074, 'admin', b'1', NULL, '2', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
                            `roleId` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色号',
                            `roleNameCn` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '中文名',
                            `roleNameEn` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '英文名',
                            `roleDescription` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '描述',
                            `utcCreate` bigint NOT NULL COMMENT '创建时间',
                            `utcModify` bigint NOT NULL COMMENT '修改时间',
                            `modifyBy` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '修改人',
                            `valid` bit(1) NOT NULL COMMENT '是否有效',
                            `remark` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
                            `customa` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '权限等级\n0：公共权限\n1：用户权限\n2：管理权限\n3：内部权限',
                            `customb` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '自定义字段b',
                            PRIMARY KEY (`roleId`,`roleNameEn`) USING BTREE,
                            KEY `roleId` (`roleId`) USING BTREE,
                            KEY `roleNameEn` (`roleNameEn`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES ('1', '管理员', 'admin', '管理员角色，拥有最高权限', 1621074167413, 1621074167413, 'Xb18620208', b'1', NULL, NULL, NULL);
INSERT INTO `sys_role` VALUES ('2', '承租方', 'buyer', '承租商品角色', 1621074167413, 1621074167413, 'Xb18620208', b'1', NULL, NULL, NULL);
INSERT INTO `sys_role` VALUES ('3', '出租方', 'saler', '出租商品角色', 1621074167413, 1621074167413, 'Xb18620208', b'1', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
                            `userName` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名',
                            `userPassword` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码',
                            `userNick` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '姓名',
                            `userGender` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '性别',
                            `userPhone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '电话',
                            `userEmail` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
                            `userQuest` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密保问题',
                            `userAnswer` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密保答案',
                            `userAvatar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '头像',
                            `userLastLogin` bigint DEFAULT NULL COMMENT '最近登录时间',
                            `utcCreate` bigint NOT NULL COMMENT '创建时间',
                            `utcModify` bigint NOT NULL COMMENT '修改时间',
                            `modifyBy` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '修改人',
                            `valid` bit(1) NOT NULL COMMENT '是否有效',
                            `remark` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
                            `customa` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '自定义字段a',
                            `customb` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '自定义字段b',
                            PRIMARY KEY (`userName`) USING BTREE,
                            KEY `userName` (`userName`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES ('admin', 'admin', 'admin', '男', '13506839371', '845923059@qq.com', '您的大学叫什么？', '科艺', 'https://tremblingoss.oss-cn-shanghai.aliyuncs.com/2022/04/14/logo.png', 1649934448181, 1621700765210, 1649942853663, 'admin', b'1', NULL, NULL, NULL);
INSERT INTO `sys_user` VALUES ('buyer', 'admin', '承租方', '女', '13565120077', 'hxy1999@gmail.com', '您最好的朋友叫什么？', 'jzk', 'https://tremblingoss.oss-cn-shanghai.aliyuncs.com/2022/04/14/logo.png', 1622906349853, 1621873543898, 1621873543898, 'admin', b'1', NULL, NULL, NULL);
INSERT INTO `sys_user` VALUES ('buyer2', 'admin', '承租方2', '女', '13459834838', '2@qq.com', '您的大学叫什么？', '科艺', 'https://tremblingoss.oss-cn-shanghai.aliyuncs.com/2022/04/14/logo.png', 1622906129536, 1621873937734, 1621875584846, 'admin', b'1', NULL, NULL, NULL);
INSERT INTO `sys_user` VALUES ('saler', 'admin', '出租方', '男', '13506839372', '888888888@qq.com', '您的大学叫什么？', '科艺', 'https://tremblingoss.oss-cn-shanghai.aliyuncs.com/2022/04/14/logo.png', 1622906281157, 1621873454905, 1621873982071, 'saler', b'1', NULL, NULL, NULL);
INSERT INTO `sys_user` VALUES ('saler2', 'admin', '出租方2', '男', '13311111111', '121212@11.com', '您的大学叫什么？', '科艺', 'https://tremblingoss.oss-cn-shanghai.aliyuncs.com/2022/04/14/logo.png', 1622906318310, 1621873918374, 1621875604877, 'admin', b'1', NULL, NULL, NULL);
INSERT INTO `sys_user` VALUES ('test', 'admin', '测试用户', '男', '13509090909', 'oxoxoxoxoxo@163.com', '您的电子邮箱是？', 'oxoxoxoxoxo@163.com', 'https://tremblingoss.oss-cn-shanghai.aliyuncs.com/2022/04/14/logo.png', NULL, 1621873643774, 1621873643774, 'admin', b'1', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_address
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_address`;
CREATE TABLE `sys_user_address` (
                                    `id` int NOT NULL AUTO_INCREMENT COMMENT '序号',
                                    `userName` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名',
                                    `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '地址',
                                    `utcCreate` bigint NOT NULL COMMENT '创建时间',
                                    `utcModify` bigint NOT NULL COMMENT '修改时间',
                                    `modifyBy` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '修改人',
                                    `valid` bit(1) NOT NULL COMMENT '是否有效',
                                    `remark` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
                                    `customa` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '自定义字段a',
                                    `customb` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '自定义字段b',
                                    PRIMARY KEY (`id`,`userName`) USING BTREE,
                                    KEY `id` (`id`) USING BTREE,
                                    KEY `SUAuserName` (`userName`) USING BTREE,
                                    CONSTRAINT `SUAuserName` FOREIGN KEY (`userName`) REFERENCES `sys_user` (`userName`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统用户地址表';

-- ----------------------------
-- Records of sys_user_address
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_address` VALUES (1, 'admin', 'admin测试地址', 1621873376500, 1621873376500, 'admin', b'1', NULL, NULL, NULL);
INSERT INTO `sys_user_address` VALUES (2, 'admin', 'admin承租方地址', 1621873384606, 1621873384606, 'admin', b'1', NULL, NULL, NULL);
INSERT INTO `sys_user_address` VALUES (3, 'admin', 'admin出租房地址', 1621873391202, 1621873391202, 'admin', b'1', NULL, NULL, NULL);
INSERT INTO `sys_user_address` VALUES (4, 'saler', '出租方地址', 1621874003044, 1621874003044, 'saler', b'1', NULL, NULL, NULL);
INSERT INTO `sys_user_address` VALUES (5, 'saler', '发货地址1', 1621874008811, 1621874008811, 'saler', b'1', NULL, NULL, NULL);
INSERT INTO `sys_user_address` VALUES (6, 'saler2', '2号出租方地址', 1621874564556, 1621874564556, 'saler2', b'1', NULL, NULL, NULL);
INSERT INTO `sys_user_address` VALUES (7, 'saler2', '测试发货地址2', 1621874572479, 1621874572479, 'saler2', b'1', NULL, NULL, NULL);
INSERT INTO `sys_user_address` VALUES (8, 'buyer', '买家收货地址', 1621874791682, 1621874791682, 'buyer', b'1', NULL, NULL, NULL);
INSERT INTO `sys_user_address` VALUES (9, 'buyer', '浙江理工大学科技与艺术学院', 1621874804457, 1621874804457, 'buyer', b'1', NULL, NULL, NULL);
INSERT INTO `sys_user_address` VALUES (10, 'buyer2', '2号买家地址', 1621875488119, 1621875488119, 'buyer2', b'1', NULL, NULL, NULL);
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;
